# 导入蓝图模块
from flask import Blueprint,request,json,jsonify
# 实例化
from db import db1
bp_course = Blueprint("course",__name__)

# 接口
@bp_course.route('/course',methods=['POST','GET','PUT','DELETE'])
def course():
    # 添加
    if  request.method=='POST':
        # 获取用户输入
        data=request.data
        if data:
            data=json.loads(data)
        else:
            data=request.form
        # 构造sql语句
        sql="insert into coupon values(0,'%s',%d,'%s','%s')"%(data['name'],int(data['total']),data['start'],data['end'])
        db1.insert(sql)
        return 'ok'
    elif request.method =='GET':
        #根据id获取信息
        id = request.args.get('id')
        sql = "select * from test where id=%d"(int(id))
        res = db1.find(sql)
        return jsonify({"code":200,'test':res})
    elif request.method == 'PUT':
        # 修改
        # 获取用户输入  
        data = request.data
        if data:
            data = json.loads(data)
        else:
            data = request.form
        print(data)
        # 构造sql语句 update 表名coupon set 字段名1=值 字段名2=值 where id=1
        sql = "update coupon set name='%s',total=%d,starttime='%s',endtime='%s' where id=%d"%(data['name'],int(data['total']),data['stime'],data['etime'],int(data['id']))
        print(sql)
        db1.insert(sql)
        return jsonify({"code":200})

    elif request.method == "DELETE":
        id = request.args.get('id')
        sql = "delete from coupon where id=%d"%(int(id))
        db1.insert(sql)
        return jsonify({"code":200}) 